package com.troyhigh.njrotc.admintrackerold;

import java.util.ArrayList;
import java.sql.Date;

public interface Database
{
    public void connect();
    public boolean isConnected();
    public void disconnect();
    public void committ();
    
    public boolean studentExists(Student s);
    public boolean eventExists(Event e);
    
    public ArrayList<Student> getStudents();
    public ArrayList<Event> getEvents();
    public ArrayList<Student> getStudents(String f, String l, int id);
    public ArrayList<Event> getEvents(String n, Date d);
    public Student getStudent(String f, String l, int id);
    public Event getEvent(String n, Date d);
    //public Hashtable<Integer, Integer> getRoster(Event e);
    public ArrayList<RibbonData> getAwards();
    public ArrayList<RibbonData> getAwards(int id);
    public RibbonData getAward(int id);
    
    public void setStudents(ArrayList<Student> s);
    public void setEvents(ArrayList<Event> e);
    public void setStudent(Student s);
    public void setEvent(Event e);
    public void setRoster(Event e);
    public void setAwards(ArrayList<RibbonData> r);
    public void setAward(RibbonData r);
    
    public void removeStudent(String f, String l, int id);
    public void removeEvent(String n, Date d);  
}
    